USE [Tibet]
GO
/****** Object:  StoredProcedure [dbo].[SELUsuarioClave]    Script Date: 06/26/2011 05:06:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*procedimiento que agrega un nuevo cliente en la BD*/
ALTER PROCEDURE [dbo].[SELUsuarioClave]
@email varchar(50)

AS

BEGIN

select c.UsernameCredencial as alias, c.ClaveCredencial as clave 
from Usuario u, Credencial c
where c.Fk_idUsuario=u.idUsuario and u.CorreoElectronico=@email;
		
END

SET ANSI_NULLS ON